package com.sto.stoapp.db.constant;

/**
 * 路由表Constant
 * 
 * @author mgf
 * 
 */
public interface StoRouteConstant extends StoBaseConstant {



	public static final String NEXT_ORG_NAME = "nextOrgName";
	public static final String DES_ORG_NAME = "desOrgName";
	/**
	 * 路由号
	 */
	public static final String ROUTE_CODE = "route_code";
	/**
	 * 下一目的地
	 */
	public static final String NEXT_STATION = "next_station";
	/**
	 * 二级中转目的地
	 */
	public static final String CENTER_DES = "center_Des";
	/**
	 * 分拨班次
	 */
	public static final String SHIFT = "shift";
	/**
	 * 运输方式
	 */
	public static final String TRAN_TYPE = "tran_type";

	/**
	 * 路由表
	 */
	public static final String TAB_ROUTE = "tab_route";

	/**
	 * 创建路由表
	 */
	public static final String CREATE_ROUTE_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ TAB_ROUTE
			+ "("
			+ ID
			+ " text PRIMARY KEY "
			+ ","
			+ VERSION
			+ " text "
			+ ","
			+ DES_ORG_NAME
			+ " text "
			+ ","
			+ NEXT_ORG_NAME
			+ " text "
			+ ","
			+STATUS
			+" text "
			+","
			+ ROUTE_CODE
			+ " char(20)"
			+ ","
			+ NEXT_STATION
			+ " char(20)"
			+ ","
			+ CENTER_DES
			+ " char(20)"
			+ ","
			+ SHIFT
			+ " char(20)"
			+ ","
			+ TRAN_TYPE
			+ " char(20)"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE
			+ " char(50)"
			+ ")";

	/**
	 * 删除路由表
	 */
	public static final String DROP_ROUTE_TABLE = "drop table if exists "
			+ TAB_ROUTE;
}
